<?php
//Usuario.php
include "../functions/dbfunctions.php";

class Usuario{
        
    public static function listarEspecialistas() {
        $consulta = "SELECT *
                     FROM USUARIOS U
                     WHERE 
                         UPPER(U.ESPECIALIDAD) = 'PSICOPEDAGOGA' OR
                         UPPER(U.ESPECIALIDAD) LIKE 'ADMINISTRADOR%'";
        $result = real_ret_arrayi($consulta, array());
        return $result;
    }
    public static function login($user,$pass) {
        $getRut = "SELECT *
                   FROM
                        USUARIOS U
                   WHERE
                        NOMBRE_USUARIO = :user AND
                        PASS = :pass";
        $tmp = real_ret_arrayi($getRut, array(":user" => $user, ":pass" => $pass ));
        return $result;
    }
    
}

?>
